

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
<head>
<script type="text/javascript" src="helpman_topicinit.js"></script>

<title>Set Oracle Table Properties [Enterprise Architect User Guide]</title>

<meta name="keywords" content="Enterprise Architect, Sparx Systems, UML, Oracle,Oracle Tables, Set Properties,Oracle Tables, Tagged Values,Oracle Temporary Table,Tagged Value,Tagged Value For Oracle Table Properties,Data Modeling,Data Modeling Set Oracle Table Properties">
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<meta http-equiv="Content-Style-Type" content="text/css" />

<link type="text/css" href="default.css" rel="stylesheet" />
<style type="text/css">
  A, A:Visited
  {
    color: #00F;
  }

  A:Active, A:Hover
  {
    color: #F00;
  }

  OL
  {
    margin: 5px 0 5px 48px;
  }

  UL
  {
    margin-bottom: 3px;
    margin-top: 0;
  }

  #nsr
  {
    background-color: #D4DFFF;
  }

  #nsr A
  {
    text-decoration: none;
  }

  #mainbody
  {
    padding: 8px;
  }

  .p_BodyText
  {
    padding: 5px 0;
  }
</style>



<style type="text/css" media="screen">
  BODY
  {
    background-color: #FFFFFF;
  }

  #nsr
  {
    padding: 6px 6px 0 6px;
    border-bottom: none;
    vertical-align: top;
    z-index: 2;
    visibility: visible;
    left: 0;
    top: 0;
    position: absolute;
  }

  #mainbody
  {
    left: 0;
    top: 0;
    margin: 0;
    position: absolute;
    padding: 10px;
    overflow: auto;
    height: 100%;
    z-index: 1;
    background-repeat: no-repeat;
    background-position: bottom right;
    background-attachment: fixed;
  }
</style>

<style type="text/css" media="print">
  #nsr
  {
    visibility: none;
  }

  #mainbody
  {
    overflow: visible;
  }
</style>
<script type="text/javascript" language="JavaScript" src="nonscroll.js"></script>

</head>
<body scroll="no">

<div id="page">



        <div id="content">
          <div id="content-inner">
          



  
          <div id="nsr">
            <table border="0" cellspacing="0" cellpadding="4" width="100%">
              <tr valign="top">
                <td align="left">
  


                  <p class="p_Heading1"><span class="f_Heading1">Set Oracle Table Properties</span></p>



  
                </td>
                <td align="right">
                  <a href="introduction.htm" onmouseover="document.images.main.src='button_main_h.gif'" onmouseout="document.images.main.src='button_main.gif'">
                    <img name="main" src="button_main.gif" border=0 alt="Return to Introduction">
                  </a>&nbsp;
    
                  <a href="setmysqltabletype.htm" onmouseover="document.images.prev.src='button_prev_h.gif'" onmouseout="document.images.prev.src='button_prev.gif'">
                    <img name=prev src="button_prev.gif" border=0 alt="Previous page" />
                  </a>&nbsp;
    
    
    
                  <a href="createcolumns.htm" onmouseover="document.images.next.src='button_next_h.gif'" onmouseout="document.images.next.src='button_next.gif'">
                    <img name=next src="button_next.gif" border=0 alt="Next page" />
                  </a>
    
    
                </td>
              </tr>
            </table>
          </div>
          <div id="mainbody">
  


                <p class="p_BodyText"><span class="f_BodyText">For Oracle, you can set table properties using the table's Tagged Values. Follow the steps below:</span></p>
<ol style="text-indent: 0px; margin-left: 48px; list-style-position: outside;">
<li value=1><span class="f_NumberedList">Select the </span><span class="f_MenuKeyField">View | Tagged Values</span><span class="f_NumberedList"> menu option, or press </span><span class="f_MenuKeyField">[Ctrl]</span><span class="f_NumberedList">+</span><span class="f_MenuKeyField">[Shift]</span><span class="f_NumberedList">+</span><span class="f_MenuKeyField">[6]</span><span class="f_NumberedList">. The </span><span class="f_UIControl">Tagged Values</span><span class="f_NumberedList"> window displays.</span></li>
<li value=2><span class="f_NumberedList">Click on the table in a diagram or in the </span><span class="f_UIControl">Project Browser</span><span class="f_NumberedList">. The </span><span class="f_UIControl">Tagged Values</span><span class="f_NumberedList"> window displays the table name, selected.</span></li>
<li value=3><span class="f_NumberedList">Click on the </span><img src="newtagicon.png" width="24" height="23" border="0" alt="NewTagIcon"><span class="f_NumberedList"> (</span><span class="f_MenuKeyField">New Tag</span><span class="f_NumberedList">) button.</span></li>
<li value=4><span class="f_NumberedList">Define the table properties as shown in the examples below:</span><br>
<span class="f_NumberedList">&nbsp;</span><br>
<img src="oracle_tag_tablespace.png" width="353" height="169" border="0" alt="oracle_tag_tablespace"><br>
<span class="f_NumberedList">&nbsp;</span><br>
<img src="oracle_tag_storage.png" width="353" height="169" border="0" alt="oracle_tag_storage"><br>
<span class="f_NumberedList">&nbsp;</span></li>
</ol>
<ol style="text-indent: 0px; margin-left: 48px; list-style-position: outside;">
<li value=5><span class="f_NumberedList">Click on the </span><span class="f_MenuKeyField">OK</span><span class="f_NumberedList"> button to save the Tagged Value.</span></li>
</ol>
<p class="p_BodyText"><span class="f_BodyText">All available properties for an Oracle table are listed below.</span></p>
<div style="text-align: left; text-indent: 0px; padding: 0px 0px 0px 0px; margin: 5px 0px 5px 13px;"><table cellspacing="0" cellpadding="2" border="0" style="border: none; border-spacing:0px;">
<tr style="text-align:left;vertical-align:bottom;">
<td valign="bottom" width="952" bgcolor="#efeff7" style="width:952px; background-color:#efeff7;"><p class="p_TiporNote" style="border-top: none; border-right: none; border-left: none;"><span class="f_TiporNote">Note:</span></p>
</td>
</tr>
<tr style="text-align:left;">
<td width="952" bgcolor="#f7f7ff" style="width:952px; background-color:#f7f7ff;"><p class="p_TiporNoteText"><span class="f_TiporNoteText">The same properties can be added to <a href="indexestriggers.htm">indexes and constraints</a>. Highlight the index or constraint and add the properties as Tagged Values.</span></p>
</td>
</tr>
</table>
</div>
<div style="text-align: left; text-indent: 0px; padding: 0px 0px 0px 0px; margin: 5px 0px 5px 13px;"><table cellspacing="0" cellpadding="1" border="0" style="border: none; border-spacing:0px; border-collapse: collapse;">
<tr style="text-align:left;vertical-align:top;">
<td valign="top" width="123" bgcolor="#e3e6ed" style="width:123px; background-color:#e3e6ed; border: solid 1px #000000;"><p class="p_Tableheader"><span class="f_Tableheader">Property</span></p>
</td>
<td valign="top" width="291" bgcolor="#e3e6ed" style="width:291px; background-color:#e3e6ed; border: solid 1px #000000;"><p class="p_Tableheader"><span class="f_Tableheader">Value</span></p>
</td>
</tr>
<tr style="text-align:left;vertical-align:top;">
<td valign="top" width="123" style="width:123px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">BUFFER_POOL</span></p>
</td>
<td valign="top" width="291" style="width:291px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">DEFAULT</span></p>
</td>
</tr>
<tr style="text-align:left;vertical-align:top;">
<td valign="top" width="123" style="width:123px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">CACHE</span></p>
</td>
<td valign="top" width="291" style="width:291px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">NOCACHE</span></p>
</td>
</tr>
<tr style="text-align:left;vertical-align:top;">
<td valign="top" width="123" style="width:123px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">DBVERSION</span></p>
</td>
<td valign="top" width="291" style="width:291px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">9.0.111</span></p>
</td>
</tr>
<tr style="text-align:left;vertical-align:top;">
<td valign="top" width="123" style="width:123px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">FREELISTS</span></p>
</td>
<td valign="top" width="291" style="width:291px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">1</span></p>
</td>
</tr>
<tr style="text-align:left;vertical-align:top;">
<td valign="top" width="123" style="width:123px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">GRANT OWNER1</span></p>
</td>
<td valign="top" width="291" style="width:291px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">SELECT</span></p>
</td>
</tr>
<tr style="text-align:left;vertical-align:top;">
<td valign="top" width="123" style="width:123px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">GRANT OWNER2</span></p>
</td>
<td valign="top" width="291" style="width:291px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">DELETE, INSERT, SELECT, UPDATE</span></p>
</td>
</tr>
<tr style="text-align:left;vertical-align:top;">
<td valign="top" width="123" style="width:123px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">INITIAL</span></p>
</td>
<td valign="top" width="291" style="width:291px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">65536</span></p>
</td>
</tr>
<tr style="text-align:left;vertical-align:top;">
<td valign="top" width="123" style="width:123px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">INITRANS</span></p>
</td>
<td valign="top" width="291" style="width:291px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">1</span></p>
</td>
</tr>
<tr style="text-align:left;vertical-align:top;">
<td valign="top" width="123" style="width:123px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">LOGGING</span></p>
</td>
<td valign="top" width="291" style="width:291px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">LOGGING</span></p>
</td>
</tr>
<tr style="text-align:left;vertical-align:top;">
<td valign="top" width="123" style="width:123px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">MAXEXTENTS</span></p>
</td>
<td valign="top" width="291" style="width:291px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">2147483645</span></p>
</td>
</tr>
<tr style="text-align:left;vertical-align:top;">
<td valign="top" width="123" style="width:123px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">MAXTRANS</span></p>
</td>
<td valign="top" width="291" style="width:291px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">255</span></p>
</td>
</tr>
<tr style="text-align:left;vertical-align:top;">
<td valign="top" width="123" style="width:123px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">MINEXTENTS</span></p>
</td>
<td valign="top" width="291" style="width:291px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">1</span></p>
</td>
</tr>
<tr style="text-align:left;vertical-align:top;">
<td valign="top" width="123" style="width:123px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">MONITORING</span></p>
</td>
<td valign="top" width="291" style="width:291px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">MONITORING</span></p>
</td>
</tr>
<tr style="text-align:left;vertical-align:top;">
<td valign="top" width="123" style="width:123px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">OWNER</span></p>
</td>
<td valign="top" width="291" style="width:291px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">OWNER1</span></p>
</td>
</tr>
<tr style="text-align:left;vertical-align:top;">
<td valign="top" width="123" style="width:123px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">PARALLEL</span></p>
</td>
<td valign="top" width="291" style="width:291px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">NOPARALLEL</span></p>
</td>
</tr>
<tr style="text-align:left;vertical-align:top;">
<td valign="top" width="123" style="width:123px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">PCTFREE</span></p>
</td>
<td valign="top" width="291" style="width:291px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">10</span></p>
</td>
</tr>
<tr style="text-align:left;vertical-align:top;">
<td valign="top" width="123" style="width:123px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">PCTINCREASE</span></p>
</td>
<td valign="top" width="291" style="width:291px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">0</span></p>
</td>
</tr>
<tr style="text-align:left;vertical-align:top;">
<td valign="top" width="123" style="width:123px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">PCTUSED</span></p>
</td>
<td valign="top" width="291" style="width:291px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">0</span></p>
</td>
</tr>
<tr style="text-align:left;vertical-align:top;">
<td valign="top" width="123" style="width:123px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">SYNONYMS</span></p>
</td>
<td valign="top" width="291" style="width:291px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">PUBLIC:TABLE_PUB;OWNER2:TABLE_OWNER2</span></p>
</td>
</tr>
<tr style="text-align:left;vertical-align:top;">
<td valign="top" width="123" style="width:123px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">TABLESPACE</span></p>
</td>
<td valign="top" width="291" style="width:291px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">MY_TABLESPACE</span></p>
</td>
</tr>
<tr style="text-align:left;vertical-align:top;">
<td valign="top" width="123" style="width:123px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">TEMPORARY</span></p>
</td>
<td valign="top" width="291" style="width:291px; border: solid 1px #000000;"><p class="p_Tabletext"><span class="f_Tabletext">YES</span></p>
</td>
</tr>
</table>
</div>
<p class="p_BodyText"><span class="f_BodyText">&nbsp;</span></p>
<p class="p_BodyText"><span class="f_BodyText">The properties defined for a given table are listed on the </span><span class="f_UIControl">Tagged Values</span><span class="f_BodyText"> window, as illustrated by the following typical Tagged Value list:</span></p>
<p class="p_TextIndentedL2"><img src="oracle_tag_disabled.png" width="259" height="362" border="0" alt="oracle_tag_disabled"></p>




            </div>
          </div>
        </div>



</div>


</body>
</html>
